<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
 <head>
  <meta http-equiv="content-type" content="text/html; charset=UTF-8">
  <title>Get row as an associative array</title>
 </head>
 <body class="docs"><div id="layout">
  <div id="layout-content"><div id="function.ifx-fetch-row" class="refentry">
 <div class="refnamediv">
  <h1 class="refname">ifx_fetch_row</h1>
  <p class="verinfo">(PHP 4, PHP 5 &lt; 5.2.1)</p><p class="refpurpose"><span class="refname">ifx_fetch_row</span> &mdash; <span class="dc-title">Get row as an associative array</span></p>

 </div>
 
 <div class="refsect1 description" id="refsect1-function.ifx-fetch-row-description">
  <h3 class="title">说明</h3>
  <div class="methodsynopsis dc-description">
   <span class="methodname"><strong>ifx_fetch_row</strong></span>
    ( <span class="methodparam"><span class="type">resource</span> <code class="parameter">$result_id</code></span>
   [, <span class="methodparam"><span class="type"><a href="language.pseudo-types.html#language.types.mixed" class="type mixed">mixed</a></span> <code class="parameter">$position</code></span>
  ] ) : <span class="type">array</span></div>

  <p class="para rdfs-comment">
   Fetches one row of data from the result associated with the specified
   result identifier.
  </p>
  <p class="para">
   Subsequent calls to <span class="function"><strong>ifx_fetch_row()</strong></span> would return the
   next row in the result set, or <strong><code>FALSE</code></strong> if there are no  more rows.
  </p>
 </div>


 <div class="refsect1 parameters" id="refsect1-function.ifx-fetch-row-parameters">
  <h3 class="title">参数</h3>
  <p class="para">
   <dl>

    
     <dt>
<code class="parameter">result_id</code></dt>

     <dd>

      <p class="para">
       <code class="parameter">result_id</code> is a valid resultid returned by
       <span class="function"><a href="ifx_query.html" class="function">ifx_query()</a></span> or
       <span class="function"><a href="ifx_prepare.html" class="function">ifx_prepare()</a></span> (select type queries only!).
      </p>
     </dd>

    
    
     <dt>
<code class="parameter">position</code></dt>

     <dd>

      <p class="para">
       An optional parameter for a &quot;fetch&quot; operation on &quot;scroll&quot; cursors:
       <em>NEXT</em>, <em>PREVIOUS</em>,
       <em>CURRENT</em>, <em>FIRST</em>, 
       <em>LAST</em> or a number.  If you specify a number, an
       &quot;absolute&quot; row fetch is executed.  This parameter is optional, and
       only valid for SCROLL cursors.
      </p>
     </dd>

    
   </dl>

  </p>
 </div>


 <div class="refsect1 returnvalues" id="refsect1-function.ifx-fetch-row-returnvalues">
  <h3 class="title">返回值</h3>
  <p class="para">
   Returns an associative array that corresponds to the fetched row, or
   <strong><code>FALSE</code></strong> if there are no more rows.
  </p>
  <p class="para">
   Blob columns are returned as integer blob id values for use in
   <span class="function"><a href="ifx_get_blob.html" class="function">ifx_get_blob()</a></span> unless you have used
   ifx_textasvarchar(1) or ifx_byteasvarchar(1), in which case blobs
   are returned as string values.
  </p>
 </div>


 <div class="refsect1 examples" id="refsect1-function.ifx-fetch-row-examples">
  <h3 class="title">范例</h3>
  <p class="para">
   <div class="example" id="example-1287">
    <p><strong>Example #1 Informix fetch rows</strong></p>
    <div class="example-contents">
<div class="phpcode"><pre><span style="color: #000000">
<span style="color: #0000BB">&lt;?php<br />$rid&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">ifx_prepare&nbsp;</span><span style="color: #007700">(</span><span style="color: #DD0000">"select&nbsp;*&nbsp;from&nbsp;emp&nbsp;where&nbsp;name&nbsp;like&nbsp;"&nbsp;</span><span style="color: #007700">.&nbsp;</span><span style="color: #0000BB">$name</span><span style="color: #007700">,<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">$connid</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">IFX_SCROLL</span><span style="color: #007700">);<br />if&nbsp;(!&nbsp;</span><span style="color: #0000BB">$rid</span><span style="color: #007700">)&nbsp;{<br />&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #FF8000">/*&nbsp;...&nbsp;error&nbsp;...&nbsp;*/<br /></span><span style="color: #007700">}<br /></span><span style="color: #0000BB">$rowcount&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">ifx_affected_rows</span><span style="color: #007700">(</span><span style="color: #0000BB">$rid</span><span style="color: #007700">);<br />if&nbsp;(</span><span style="color: #0000BB">$rowcount&nbsp;</span><span style="color: #007700">&gt;&nbsp;</span><span style="color: #0000BB">1000</span><span style="color: #007700">)&nbsp;{<br />&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">printf&nbsp;</span><span style="color: #007700">(</span><span style="color: #DD0000">"Too&nbsp;many&nbsp;rows&nbsp;in&nbsp;result&nbsp;set&nbsp;(%d)\n&lt;br&nbsp;/&gt;"</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">$rowcount</span><span style="color: #007700">);<br />&nbsp;&nbsp;&nbsp;&nbsp;die&nbsp;(</span><span style="color: #DD0000">"Please&nbsp;restrict&nbsp;your&nbsp;query&lt;br&nbsp;/&gt;\n"</span><span style="color: #007700">);<br />}<br />if&nbsp;(!&nbsp;</span><span style="color: #0000BB">ifx_do&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">$rid</span><span style="color: #007700">))&nbsp;{<br />&nbsp;&nbsp;&nbsp;</span><span style="color: #FF8000">/*&nbsp;...&nbsp;error&nbsp;...&nbsp;*/<br /></span><span style="color: #007700">}<br /></span><span style="color: #0000BB">$row&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">ifx_fetch_row&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">$rid</span><span style="color: #007700">,&nbsp;</span><span style="color: #DD0000">"NEXT"</span><span style="color: #007700">);<br />while&nbsp;(</span><span style="color: #0000BB">is_array</span><span style="color: #007700">(</span><span style="color: #0000BB">$row</span><span style="color: #007700">))&nbsp;{<br />&nbsp;&nbsp;&nbsp;&nbsp;for&nbsp;(</span><span style="color: #0000BB">reset</span><span style="color: #007700">(</span><span style="color: #0000BB">$row</span><span style="color: #007700">);&nbsp;</span><span style="color: #0000BB">$fieldname</span><span style="color: #007700">=</span><span style="color: #0000BB">key</span><span style="color: #007700">(</span><span style="color: #0000BB">$row</span><span style="color: #007700">);&nbsp;</span><span style="color: #0000BB">next</span><span style="color: #007700">(</span><span style="color: #0000BB">$row</span><span style="color: #007700">))&nbsp;{<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">$fieldvalue&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">$row</span><span style="color: #007700">[</span><span style="color: #0000BB">$fieldname</span><span style="color: #007700">];<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">printf&nbsp;</span><span style="color: #007700">(</span><span style="color: #DD0000">"%s&nbsp;=&nbsp;%s,"</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">$fieldname</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">$fieldvalue</span><span style="color: #007700">);<br />&nbsp;&nbsp;&nbsp;&nbsp;}<br />&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">printf</span><span style="color: #007700">(</span><span style="color: #DD0000">"\n&lt;br&nbsp;/&gt;"</span><span style="color: #007700">);<br />&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">$row&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">ifx_fetch_row</span><span style="color: #007700">(</span><span style="color: #0000BB">$rid</span><span style="color: #007700">,&nbsp;</span><span style="color: #DD0000">"NEXT"</span><span style="color: #007700">);<br />}<br /></span><span style="color: #0000BB">ifx_free_result&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">$rid</span><span style="color: #007700">);<br /></span><span style="color: #0000BB">?&gt;</span>
</span>
</pre></div>
    </div>

   </div>
  </p>
 </div>


</div></div></div></body></html>